
Question 5/6
"Investor Performance"
Your solution will be scored against expected output.
The table, INVESTOR_TABLE_2019, contains performance data for the investors working at an investment company in 2019.
Write a query which will return the INVESTOR_IDs of the investors whose investment accounts experienced a greater than average percentage return in 2019 amongst all investors. Order your results by INVESTOR_ID in ascending order.
In the returned query be sure to use the column names used in the sample output given below.
Table Name : INVESTOR_TABLE_2019
The percentage returns for investors 196208, 196202, 196212, and 196298 are 0.10, -0.70, 1.00, and 0.20 respectively, which means the average percent return amongst these investors is 0.15.
Therefore, the sample output consists of two rows containing the investor ids of the two investors who attained higher than average percentage returns.
Java
Javascript
Python-3
PHP-7
Ruby
C
C++
Go
Scala
Objective-C
Swift-5
Java
Javascript
Python-3
PHP-7
Ruby
C
C++
Go
Scala
Objective-C
Swift-5
SQL
SQL